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