UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dX0yONtmGU9NLuM2WpWWGOS/4Gw6NE8Ttov+SgM7cCs=' 
WHERE 
  key_id = '07862bd6f6d1b2337c5f7f2cd0a730335d0bf2329977614f99144a23fa3fd7f3' 
  AND (
    token = 'dX0yONtmGU9NLuM2WpWWGOS/4Gw6NE8Ttov+SgM7cCs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041