UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KFyIgAECQj0NhCD6pkyvjY72UUyNoNtK4vZQxLTwkfo='
WHERE
key_id = 'a24a56fb9a87d2eb12786ef6d72aafe95649b8c213ed1094eb3c612873d85549'
AND (
token = 'KFyIgAECQj0NhCD6pkyvjY72UUyNoNtK4vZQxLTwkfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)