UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmYVexVGN6D291t7tmpUUjYc7zjWs3pu4/SKIr70IAU='
WHERE
key_id = 'cd1280947e48a5252ff1010e16e58705944ea1abe7928ca15af021db42d161f3'
AND (
token = 'CmYVexVGN6D291t7tmpUUjYc7zjWs3pu4/SKIr70IAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)