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

Query time 0.00021