UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xm1HJbNmiNBTONS7eRYd+/YoWLny/p6XIU/5Sn4df9U='
WHERE
key_id = 'e83c43d94628d9bdc469f15033885817b88c2eb83e37b47759463cf9e02099ec'
AND (
token = 'Xm1HJbNmiNBTONS7eRYd+/YoWLny/p6XIU/5Sn4df9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)