UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yqYsAqq6VJso98oLffLH8CcSgRlJCFrcw9XeF3b6p70=' 
WHERE 
  key_id = '295284eb5f2587bce10ff4420a1be7db1f9828f06ccf9f8fcdb772ae088a8e11' 
  AND (
    token = 'yqYsAqq6VJso98oLffLH8CcSgRlJCFrcw9XeF3b6p70=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020