UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PgOajsa9JX9AWrFmpkp2qiOlFVXf6LfVUI8T6ARPnSk=' 
WHERE 
  key_id = 'c593bf993be11a5ed062e61492d28c0a1b2c51a2eb2fc2e5ec5ce4969dc0829c' 
  AND (
    token = 'PgOajsa9JX9AWrFmpkp2qiOlFVXf6LfVUI8T6ARPnSk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034