UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHcaiIN51cpC8d3ehXOpfY0aV0qSMinfD1AuV6kkzi0='
WHERE
key_id = '6ab83c2603468dfa9a9b30181106615bf835f969d3502e78e664415f1ae5e41e'
AND (
token = 'gHcaiIN51cpC8d3ehXOpfY0aV0qSMinfD1AuV6kkzi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)