UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LyEq6YBviWM07EyAU0vucQBEUSsDljTHSVGg4/zPRoM='
WHERE
key_id = '07a8ddd22134becdf1a614a036f36a4367b60f9521f547bea884e6ff1aeff72b'
AND (
token = 'LyEq6YBviWM07EyAU0vucQBEUSsDljTHSVGg4/zPRoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)