UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hv4AlKEG4NJB7tIYhVJOaqVryqkr+UajSzaimZeLMCM='
WHERE
key_id = 'd49864ba7ca1dc1acaa6c2b695ee9a914159084e7f1226cf4973ead976bb4e11'
AND (
token = 'hv4AlKEG4NJB7tIYhVJOaqVryqkr+UajSzaimZeLMCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)