UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IfD9YKiF0SBepUoYZmKOIi8Pt5ssIVUX0sfY3xf7+3I='
WHERE
key_id = 'db35f4d804408cce44cccdd4f33b585401e622132dbc57d5c0cb0f9bc5001e6a'
AND (
token = 'IfD9YKiF0SBepUoYZmKOIi8Pt5ssIVUX0sfY3xf7+3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)