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