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