UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6lS5nCZZ+o8mktH3nua6+9WSLhSri+2cMflEIkL80U='
WHERE
key_id = 'aaf367a06c408ca0a2676641b3daf7bece474f37185dd2fa9127aed64fc73ea6'
AND (
token = 'o6lS5nCZZ+o8mktH3nua6+9WSLhSri+2cMflEIkL80U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)