UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcGKxCADU/wxKwAv0KDqEmY825tSKTe2iJdg5xe4th8='
WHERE
key_id = 'ea65383edfd1d7f9bc04cfb2040a78dbed82be9526f447aa9f443d060afd034a'
AND (
token = 'hcGKxCADU/wxKwAv0KDqEmY825tSKTe2iJdg5xe4th8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)