UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aLhcjFrlieLZ1WlZkVTCpeic7vxSVsBnwecw5zkcGw='
WHERE
key_id = '518f997b7d425662afb47290179ed9c46cf46b6a7f8c4ca0413115558d13ac86'
AND (
token = '+aLhcjFrlieLZ1WlZkVTCpeic7vxSVsBnwecw5zkcGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)