UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pNs8HC3IzO9tPlVaSWvhE1A9pbYqnaYuN9NsrvkuGKM=' 
WHERE 
  key_id = 'd7482c673c89df735db34845d940d4807412d41a13d3bd7f081d45f6354fd82c' 
  AND (
    token = 'pNs8HC3IzO9tPlVaSWvhE1A9pbYqnaYuN9NsrvkuGKM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026