UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jy/+OSwN+vlKCnLuYIG+Qv+0dSiPx4Th7CaQFHdh7xA=' 
WHERE 
  key_id = 'fdd35daab2eb9fc89522d0d971226ab3fb5c143569d3a1b25da1779121c79b5a' 
  AND (
    token = 'jy/+OSwN+vlKCnLuYIG+Qv+0dSiPx4Th7CaQFHdh7xA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029