UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiXTKHhd0l0s4WyhhTB7SIBo4ZHvDa7zV4Zkk8kDCo4='
WHERE
key_id = '32a2cbc736e9cf0800f69b61911953191d8f674faf2bbd43ed57481ffe6735f4'
AND (
token = 'XiXTKHhd0l0s4WyhhTB7SIBo4ZHvDa7zV4Zkk8kDCo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)