UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIybYLXjfpiA85tEBq1cD0ln70E/pgjyzKW7acK+nvg='
WHERE
key_id = 'deb993285e0c637e0778a1b92cf41b4715b6fd2d4fef260c56c5e619f454baf5'
AND (
token = 'mIybYLXjfpiA85tEBq1cD0ln70E/pgjyzKW7acK+nvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)