UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMQGd1fOk+OtRDipejQLEfnHb1hkrLPGwfGcmnp/Gd8='
WHERE
key_id = '1e394c27cada4ce321ccf607e26f548c8fb36d55e8e10910402f9cce2436a690'
AND (
token = 'BMQGd1fOk+OtRDipejQLEfnHb1hkrLPGwfGcmnp/Gd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)