UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'igGehXdy3TnjksMqqW6H2gZwBBR4UaMt4w5JyTDMKC0='
WHERE
key_id = 'a31e8cfc2ccc0063aa217914af75b7b612910b85c7ade0760a119e1e8a6ffcc0'
AND (
token = 'igGehXdy3TnjksMqqW6H2gZwBBR4UaMt4w5JyTDMKC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)