UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qHM87tnywxrRxnW//0RwNdO2/tR3IEkPsWz9qoY1mGw='
WHERE
key_id = 'f6fe69381f71a7a2ee94515407691e628d87d283465b80fb5741642349efb893'
AND (
token = 'qHM87tnywxrRxnW//0RwNdO2/tR3IEkPsWz9qoY1mGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)