UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aCf5rfJu0WmhUqt9EGZRmmGx+fCVWXhNxShx6A7PZUs=' 
WHERE 
  key_id = '79af8512176952553bfacb5e46452fe3b2bf25578ddb6c66ca143f2ad7d0af10' 
  AND (
    token = 'aCf5rfJu0WmhUqt9EGZRmmGx+fCVWXhNxShx6A7PZUs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024