UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/7OJCE/54OAmeoBFUdwObyqjq3RBgY9fiNcXjw3k9A='
WHERE
key_id = '363867c47301bccb6480eee46398e7c3dda2bd64a78992d960e066e77b682cdc'
AND (
token = 'a/7OJCE/54OAmeoBFUdwObyqjq3RBgY9fiNcXjw3k9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)