UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8VaFrcwRdTHMTl8AAs1ymeExmFrYYB/WoLyKl5z3cW8=' 
WHERE 
  key_id = 'e9348e20f3df23201abfa68df8706caeb05c2fde150fc2d898878f18bbea15a6' 
  AND (
    token = '8VaFrcwRdTHMTl8AAs1ymeExmFrYYB/WoLyKl5z3cW8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00075