UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SHOAy3p4b2M1WqODYV67y50rqaSShuimgWcxG4TRljg='
WHERE
key_id = '46d70ee2c166e7f5d6a420a511269d2e4cb160064e04f885c5b1429ff86bcf97'
AND (
token = 'SHOAy3p4b2M1WqODYV67y50rqaSShuimgWcxG4TRljg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)