UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ggdW4DZ9a2MmhHuVdtEIR1kN6TzPAGqHUn/JBOzrqH4=' 
WHERE 
  key_id = 'f28763fa08da357e138126383b2f39e076410336c5d4d1941a43743be4e64034' 
  AND (
    token = 'ggdW4DZ9a2MmhHuVdtEIR1kN6TzPAGqHUn/JBOzrqH4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043