UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZzBc8pkjsOzc20Ud4E53KYMTkyn0Fz/dyBuAlGQyik='
WHERE
key_id = 'ae48be8159d49811515ba223c498fbff405b4f4be1487b5565c860bd2552b962'
AND (
token = '9ZzBc8pkjsOzc20Ud4E53KYMTkyn0Fz/dyBuAlGQyik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)