UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Pgp3OLK1Zk30eDtmQ8uM9FKANESSVLUFY4VMT0ZYq4A=' 
WHERE 
  key_id = '8108c2a227e4a65e5d316942db4ee3ce781a9d0ccc7a906ea7468af8aad2ef0d' 
  AND (
    token = 'Pgp3OLK1Zk30eDtmQ8uM9FKANESSVLUFY4VMT0ZYq4A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033