UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IVuVcfQIomR+/sexhsIQh04TupzqtzcQvlcZYTjXWmg=' 
WHERE 
  key_id = '07c71929ef06ffdb1e97ee8e2332e928d3544a0d595a53335052351b33de9872' 
  AND (
    token = 'IVuVcfQIomR+/sexhsIQh04TupzqtzcQvlcZYTjXWmg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018