UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WWQ7EJzCuq4TkpwYDdfcA5ZPSP5xAmY7EbB6h67jBvM=' 
WHERE 
  key_id = '47ead50f324716cd93c7b2423792dfb0961d89c5addba86da206bd44258cecd4' 
  AND (
    token = 'WWQ7EJzCuq4TkpwYDdfcA5ZPSP5xAmY7EbB6h67jBvM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022