UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7JGpGtppiS+kNJJsmZKEAvy0yEWK97X+B5dAFSSeO6A='
WHERE
key_id = '2912f19643c3a051c9c4d1e97ae2e09def5e840886419c20179cab2455a6243a'
AND (
token = '7JGpGtppiS+kNJJsmZKEAvy0yEWK97X+B5dAFSSeO6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)