UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXeBlsZAKW8dOyg9mHCIvrN7I3bWeQ8qAqnt1yTRPDw='
WHERE
key_id = '247806e78f2e8fc92b4f08a4dcdba68a5470a43760d42f4efad2661a2e073363'
AND (
token = 'XXeBlsZAKW8dOyg9mHCIvrN7I3bWeQ8qAqnt1yTRPDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)