UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7SnVEs2A5FCc0QiIkvbLX26fyfdppllBli/ImlXfnjc='
WHERE
key_id = 'c2a9cacd7cd46e8fe55b244128477bc7a0f98be612e524dc8f3924e9e937de3e'
AND (
token = '7SnVEs2A5FCc0QiIkvbLX26fyfdppllBli/ImlXfnjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)