UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5f6VkC8rYx+PEH8rCKcndIbjtSn4fl84h9CqC1qPZB4='
WHERE
key_id = 'd5e47291215549a905228a5e2f3c0cfc0d07bb89453583f897e5378f6de1dee1'
AND (
token = '5f6VkC8rYx+PEH8rCKcndIbjtSn4fl84h9CqC1qPZB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)