UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vr+GLJmoT1QBR9Mj4vvGO3Z4+5rmd+1fwpP+R2vLIuY=' 
WHERE 
  key_id = '34e300123404bb0e89c033e7066bd0f525c1ffef51a600aa7544a35f45f29568' 
  AND (
    token = 'vr+GLJmoT1QBR9Mj4vvGO3Z4+5rmd+1fwpP+R2vLIuY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017