UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b0Wr0yXsZEqSi55F0qYlaR5Ivq5hgiNkrjpKPPoYeAQ='
WHERE
key_id = '519cec76562bf57e9a25c9bb7f99abc17824dec7697ef53af3c3f7f45423ffaa'
AND (
token = 'b0Wr0yXsZEqSi55F0qYlaR5Ivq5hgiNkrjpKPPoYeAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)