UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3miQn49QKmvtm6qKzRyeiu4ql4zXg03SjlAFD0RUjfk=' 
WHERE 
  key_id = '6eee0f3c261320481174e8f0ac7c754756b9886524a9ca2ff8853465d9144bf4' 
  AND (
    token = '3miQn49QKmvtm6qKzRyeiu4ql4zXg03SjlAFD0RUjfk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027