UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'M/0NbopykfHzVABNPaYFsgCKCHXvZ3ZP0skcOZtXA6w=' 
WHERE 
  key_id = '2a32ffc886f7b34401328c8efa7725e6ba0427102fc0d5ee4441c8e79cbc8e90' 
  AND (
    token = 'M/0NbopykfHzVABNPaYFsgCKCHXvZ3ZP0skcOZtXA6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021