UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JgZiouEZfNIWkpWNg1+V7if42nViEnY3A17IZKdpdsw=' 
WHERE 
  key_id = '2668d00f5bea37a8730b9a5488cb02ad18eea205aacbfbd8ba4417ec1ea666d1' 
  AND (
    token = 'JgZiouEZfNIWkpWNg1+V7if42nViEnY3A17IZKdpdsw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042