UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H7LZRvy3XOZ7CmmAevWrjfdO1Bu+wPwJ9e52e5xPiD4='
WHERE
key_id = 'baad6ec4c0c90e0539e4cb50ddaa165ee1610d854b3b6f2244e79c6eb7b4cb71'
AND (
token = 'H7LZRvy3XOZ7CmmAevWrjfdO1Bu+wPwJ9e52e5xPiD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)