UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Hr7bhmJqlnMGDz/3q9G9MVal8VR9Hx7RYqeh1Vcp1ko=' 
WHERE 
  key_id = 'fbe7ff7b27a4164cd64f9f366538297d9b8421831eddfb3a9797f2ac33963c8b' 
  AND (
    token = 'Hr7bhmJqlnMGDz/3q9G9MVal8VR9Hx7RYqeh1Vcp1ko=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038