UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jan/F9yGJgH8z3QbNUYO1FPFE+G1WXPH3alXp3gji0s='
WHERE
key_id = '0b7ef97ed069e84e23dbca5682ca1551b51c83c14b6111ee3eaabc4e5b4fb380'
AND (
token = 'jan/F9yGJgH8z3QbNUYO1FPFE+G1WXPH3alXp3gji0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)