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