UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DgmO1tqCO4YFWhZkXu26DOp34uEUwacxdN8n/JRXiXY='
WHERE
key_id = 'cba075f986d04d049ce8efcf75d4a4695f09b811ea9deb1b2e33e8064a8ae9a1'
AND (
token = 'DgmO1tqCO4YFWhZkXu26DOp34uEUwacxdN8n/JRXiXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)