UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vIKnAP3hOc95y0jkZ4PdknfqkMUhrNfketZCWzHwlfE='
WHERE
key_id = '254b674ba99c1a36790f990b3034eb53ab2d5580713c1b59f34555fe58bfff2b'
AND (
token = 'vIKnAP3hOc95y0jkZ4PdknfqkMUhrNfketZCWzHwlfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)