UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pNCm0Q2t+x0RTMuAPE/cG023js60choZYN0+0Ka9Ky0=' 
WHERE 
  key_id = '104666c6c412b33895ca93b8914863e44d2534b52c89f82f6bb9dc44ed2190e7' 
  AND (
    token = 'pNCm0Q2t+x0RTMuAPE/cG023js60choZYN0+0Ka9Ky0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041