UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0KNXUVrf8UfDl9ReRHZOV61eTG1fuACJ4Hl9Wd9wWOo=' 
WHERE 
  key_id = '765b5b884763b262e117b1f0d7d89e24ed83a27153060b7ca91eefb2ceef2ef6' 
  AND (
    token = '0KNXUVrf8UfDl9ReRHZOV61eTG1fuACJ4Hl9Wd9wWOo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022